[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '201' >
5 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 10 | 1997-12-19 | Production | scott0@adventure-works.com | Scott Gode | 391-555-0138 | 199546871 | Scott | M | 2019-11-17 | Gode | adventure-works\scott0 | M | R | 201 | 1 | 391-555-0138 | 63 | 2019-11-17 | Current | Production Technician - WC45 | 86 | |
139 | 10 | 2001-09-09 | Production | kathie0@adventure-works.com | Kathie Flood | 446-555-0118 | 167554340 | Kathie | F | 2019-12-06 | Flood | adventure-works\kathie0 | M | E | 201 | 1 | 446-555-0118 | 63 | 2019-12-06 | Current | Production Technician - WC45 | 87 | |
24 | 10 | 1973-07-22 | Production | stuart0@adventure-works.com | Stuart Munson | 413-555-0136 | 835460180 | Stuart | M | 2019-10-11 | Munson | adventure-works\stuart0 | S | V | 201 | 1 | 413-555-0136 | 62 | 2019-10-11 | Current | Production Technician - WC45 | 84 | |
25 | 10 | 1987-02-23 | Production | greg0@adventure-works.com | Greg Alderson | 332-555-0150 | 687685941 | Greg | M | 2019-10-11 | Alderson | adventure-works\greg0 | S | F | 201 | 1 | 332-555-0150 | 62 | 2019-10-11 | Current | Production Technician - WC45 | 85 | |
185 | 10 | 1986-01-23 | Production | belinda0@adventure-works.com | Belinda Newman | 319-555-0126 | 20244403 | Belinda | F | 2019-12-30 | Newman | adventure-works\belinda0 | S | M | 201 | 1 | 319-555-0126 | 61 | 2019-12-30 | Current | Production Technician - WC45 | 83 |
Generated 2025-05-08 15:44:51.274 UTC